Problem Note 60534: Incorrect data is returned from queries to SAS/ACCESS® Interface to R3 for CURR data types that use a national language format
 |  |  |  |  |
SAP R/3 might return incorrect data when queried from either SAS® Enterprise Guide®, SAS® Data Integration Studio, or SAS® Studio in the following circumstances:
- The SAS Enterprise Guide project has more than one task that queries SAP R/3, the SAS Data Integration Studio job has more than one transformation that queries SAP R/3, or the SAS Studio job has more than one task that queries SAP R/3.
- The SAP R/3 data type is CURR.
- A SAS national language format is applied to a column (for example, NLNUM18.5).
- The SAP R/3 library is NOT assigned in each task or transformation.
There is no indication of a problem in the logs. However, values returned appear to be 0. When you use the BEST32.30 format to display values, they are displayed as a very small value (for example, 1E-310).
Note: The problem has not been observed in SAS® Foundation or when you run a SAS program in batch mode.
SAS Enterprise Guide and SAS Studio Workaround
To work around the problem when using SAS Enterprise Guide or SAS Studio, do one of the following:
- Remove the national language formats from the CURR data type columns.
- Insert SAP R/3 LIBNAME statements in each task that uses these libraries. This workaround requires copying the task code and creating a program.
SAS Data Integration Studio Workaround
To work around the problem when using SAS Data Integration Studio, do one of the following:
- Remove the national language format from the CURR data type columns.
- Insert SAP R/3 LIBNAME statements in the pre-code for each task that uses these libraries.
- Go to the Code tab of the job and change the Code Generation Mode from Automatic to User Written Body.
- Deploy the job, and run it in batch mode.
- Copy the code, and run it from the SAS Data Integration Studio code editor, SAS Enterprise Guide, or SAS Foundation.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to R/3 | Solaris for x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 |
| Linux for x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| HP-UX IPF | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| 64-bit Enabled AIX | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Professional 32 bit | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Datacenter | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 for x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 R2 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise 32-bit | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft® Windows® for x64 | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| z/OS | 4.4_M4 | 4.4_M5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
A fix for this issue for SAS/ACCESS Interface to R/3 4.4_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B6X.html#60534| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-11-29 14:40:36 |
| Date Created: | 2017-05-26 04:25:13 |